package com.jy.adscm.spss.mapper.mysql;

import com.jy.adscm.spss.bean.Base_incomeexpenditure;
import com.baomidou.mybatisplus.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author yyy
 * @since 2018-11-08
 */
public interface Base_incomeexpenditureMapper extends BaseMapper<Base_incomeexpenditure> {
    /**
     * 获取收支计划和实际日期
     * @return
     */
    List<Base_incomeexpenditure> getDate();

    /**
     * 修改收支计划周
     * @param whereeek
     * @param ieid
     */

    void updatePlanWeek(@Param("whereeek")String whereeek,@Param("ieid")String ieid);

    /**
     * 修改收支实际周
     *
     * @param sjwhereweek
     * @param ieid
     */
    void updatePracticalWeek(@Param("sjwhereweek")String sjwhereweek,@Param("ieid")String ieid);

    /**
     * 查询收支计划收入和支出在每周的总金额
     * @param szlx
     * @return
     */
    List<Base_incomeexpenditure> getPlanTotal(@Param("szlx")String szlx);

    /**
     * 查询收支实际收入和支出在每周的总金额
     * @param szlx
     * @return
     */
    List<Base_incomeexpenditure> getPracticalTotal(@Param("szlx")String szlx);

    /**
     * 根据周和收支类型查询详细信息
     * @return
     */
    List<Base_incomeexpenditure> getBySZInformation(@Param("szlx")String szlx,@Param("whereWeek")String whereWeek);

    /**
     * 根据周和收支类型查询实际收支详细信息
     * @param szlx
     * @param whereWeek
     * @return
     */
    List<Base_incomeexpenditure> getBySZSJInformation(@Param("szlx")String szlx,@Param("whereWeek")String whereWeek);
}
